Unit XLSSheetData5

DescriptionUsesClasses, Interfaces, Objects and RecordsFunctions and ProceduresTypesConstantsVariables

Description

 

Uses

Overview

Classes, Interfaces, Objects and Records

Name Description
record TXLSCellSortItem  
Class TXLSSelectedArea  
Class TXLSSelectedAreas  
Class TXLSVertPagebreak  
Class TXLSVertPagebreaks  
Class TXLSHorizPagebreak  
Class TXLSHorizPagebreaks  
Class TXLSPageBreaks  
Class TXLSHeaderFooter  
Class TXLSPrintSettings  
Class TXLSPane  
Class TXLSSheetProtection  
Class TXLSWorksheet  
Class TXLSWorkbookData  
Class TXLSOptionsDialog  
Class TXLSWorkbook  

Types

TXLSDeleteOption = (...);
TXLSDeleteOptions = set of TXLSDeleteOption;
TPaneType = (...);
TActivePane = (...);
TWorkspaceOption = (...);
TWorkspaceOptions = set of TWorkspaceOption;
TWorkbookOption = (...);
TWorkbookOptions = set of TWorkbookOption;
TCopyCellsOption = (...);
TCopyCellsOptions = set of TCopyCellsOption;
TPrintSetupOption = (...);
TPrintSetupOptions = set of TPrintSetupOption;
TXLSSheetOption = (...);
TXLSSheetOptions = set of TXLSSheetOption;
TSelectedAreaHit = (...);
TSelectedEdgeHit = (...);
TSelectedEdgeHits = set of TSelectedEdgeHit;

Constants

DefaultDeleteOptions = [xdoCellValues,xdoFormats,xdoComments,xdoDataValidations,xdoConditionalFormats,xdoAutofilters,xdoDrawing];
CopyAllCells = [ccoCopyValues, ccoCopyShapes, ccoCopyNotes, ccoCopyCondFmt, ccoCopyValidations, ccoCopyMerged ];

Description

Types

TXLSDeleteOption = (...);
 
Values
  • xdoCellValues:  
  • xdoFormats:  
  • xdoComments:  
  • xdoDataValidations:  
  • xdoConditionalFormats:  
  • xdoAutofilters:  
  • xdoDrawing:  
TXLSDeleteOptions = set of TXLSDeleteOption;
 
TPaneType = (...);

Pane type when a worksheet has splitted panes.

Values
  • ptNone:  
  • ptFrozen: No panes.
  • ptSplit: Frozen panes,
  • ptFrozenSplit: Splitted panes.
TActivePane = (...);
 
Values
  • apBottomRight:  
  • apTopRight:  
  • apBottomLeft:  
  • apTopLeft:  
TWorkspaceOption = (...);
 
Values
  • woShowAutoBreaks:  
  • woApplyStyles: Automatic page breaks are visible.
  • woRowSumsBelow: Automatic styles are applied to an outline
  • woColSumsRight: Summary rows appear below detail in an outline
  • woFitToPage: Summary columns appear to the right of detail in an outline
  • woOutlineSymbols: Page fit option is on.
TWorkspaceOptions = set of TWorkspaceOption;

Outline symbols are displayed.

TWorkbookOption = (...);
 
Values
  • woHidden:  
  • woIconized: The window is hidden.
  • woHScroll: The window is displayed as an icon.
  • woVScroll: The horizontal scroll bar is displayed.
  • woTabs: The vertical scroll bar is displayed.
TWorkbookOptions = set of TWorkbookOption;

The workbook tabs are displayed.

TCopyCellsOption = (...);

Options when copying and moving cells.

Values
  • ccoAdjustCells:  
  • ccoLockStartRow: Adjust relative cells according to the new location.
  • ccoForceAdjust: Don't adjust the first row.
  • ccoCopyValues: Adjust absolute cell references as well.
  • ccoCopyShapes: Copy cell values.
  • ccoCopyNotes: Copy shape objects.
  • ccoCopyCondFmt: Copy cell notes.
  • ccoCopyValidations: Copy conditional formats.
  • ccoCopyMerged: Copy cell validations.
TCopyCellsOptions = set of TCopyCellsOption;

Copy merged cells.

TPrintSetupOption = (...);

Cell values Drawing shapes. Cell notes. Conditional formats. Cell validations. Merged cells.

Values
  • psoLeftToRight:  
  • psoPortrait:  
  • psoNoColor:  
  • psoDraftQuality:  
  • psoNotes:  
  • psoRowColHeading:  
  • psoGridlines:  
  • psoHorizCenter:  
  • psoVertCenter:  
TPrintSetupOptions = set of TPrintSetupOption;
 
TXLSSheetOption = (...);
 
Values
  • soGridlines:  
  • soRowColHeadings: Show gridlines.
  • soShowFormulas: Show row and column headings.
  • soShowZeros: Show formulas instead of formula result.
TXLSSheetOptions = set of TXLSSheetOption;

Show zero values.

TSelectedAreaHit = (...);
 
Values
  • sahNo:  
  • sahInside:  
  • sahEdge:  
  • sahActiveCell:  
TSelectedEdgeHit = (...);
 
Values
  • sehLeft:  
  • sehTop:  
  • sehRight:  
  • sehBottom:  
TSelectedEdgeHits = set of TSelectedEdgeHit;
 

Constants

DefaultDeleteOptions = [xdoCellValues,xdoFormats,xdoComments,xdoDataValidations,xdoConditionalFormats,xdoAutofilters,xdoDrawing];
 
CopyAllCells = [ccoCopyValues, ccoCopyShapes, ccoCopyNotes, ccoCopyCondFmt, ccoCopyValidations, ccoCopyMerged ];

What parts of the data on a worksheet that shall be copied/moved.


Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48